![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
EnhancementsYou may want to make some additional enhancements to improve the performance of the DSS system. Listed here are some of the items that can offer performance improvement; also listed are a few items that do not improve performance. Each item is accompanied by an explanation.
Many of these enhancements can help your performance; some may degrade performance. The specific effect on your system will vary, but the information given here is true for most general cases. Parallel Query OptionThe DSS system is probably the best application to take advantage of the Parallel Query option. The design of the Parallel Query option is centered around complex queries that access large amounts of dataas is typical of a DSS system. Here is a short list of some of the operations that can be parallelized:
All these query types are typically used in a DSS system. Because these queries are typically of long duration and involve large amounts of disk I/O, the time it takes to complete these queries can be cut drastically with the use of the Parallel Query option. Once you set up a test database and develop some test queries (hopefully similar to, if not exactly the same as, production queries), run these queries with various degrees of parallelism to determine optimal performance. If you will run these queries with other queries in production, you should also test with multiple queries. A tuning parameter set up for use with a single query may not be optimal when used with many queries in parallel. The Parallel Query option can take advantage of the concurrent nature of disk arrays. By splitting up the queries into many small pieces, you may be able to request data from all the drives in your system simultaneously, optimizing I/O performance. Oracle Parallel Server OptionThe Oracle Parallel Server option may be very beneficial to your DSS operation in two ways:
The Oracle Parallel Server option can enhance the performance of your DSS system, but only if your system is suited for the Parallel Server option. To see scaleable performance increases, the system must meet the following criteria:
If these conditions are met, you will probably benefit from using the Oracle Parallel Server option.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |